Executed SQL (Step 1):

SELECT p.product_id, SQL_CALC_FOUND_ROWS
            (SELECT price FROM ti9jo39em_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special,
            (SELECT price FROM ti9jo39em_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
            (MATCH(pd.name, pd.description) AGAINST('+NVMe' IN BOOLEAN MODE) + MATCH(p.model) AGAINST('+NVMe' IN BOOLEAN MODE)) AS relevance
            FROM ti9jo39em_product p 
            LEFT JOIN ti9jo39em_product_description pd ON (p.product_id = pd.product_id) 
            LEFT JOIN ti9jo39em_product_to_store p2s ON (p.product_id = p2s.product_id) 
            WHERE pd.language_id IN (1,2) 
                AND p.status = '1' 
                AND p.date_available <= NOW() 
                AND p2s.store_id = '0'
                AND p.quantity > 0
                AND (MATCH(pd.name, pd.description) AGAINST('+NVMe' IN BOOLEAN MODE) OR MATCH(p.model) AGAINST('+NVMe' IN BOOLEAN MODE))
            GROUP BY p.product_id ORDER BY (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) ASC, LCASE(pd.name) ASC LIMIT 0,20

Number of Rows from Step 1:

Raw Results from Step 1:

string(12) "Query Failed"